﻿-- =============================================
-- Script Template
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [UserRole]'
GO

INSERT [UserRole] ([UserKey], [UserRoleKey], [UserLoginID], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 1, N'SystemSuperAdmin', N'SYSSPRADM', N'System Super Admin', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserRole] ([UserKey], [UserRoleKey], [UserLoginID], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 2, N'mrinmoyd', N'SYSADMIN', N'System Admin', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserRole] ([UserKey], [UserRoleKey], [UserLoginID], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 3, N'mrinmoyd', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))